<?php



class JobeetCategoryPeer extends BaseJobeetCategoryPeer {
    static public function getWithJobs()
    {
        $criteria = new Criteria();
        $criteria->addJoin(self::ID, JobeetJobPeer::CATEGORY_ID);
        $criteria->add(JobeetJobPeer::EXPIRES_AT, time(), Criteria::GREATER_THAN);
        $criteria->setDistinct();

        $criteria->add(JobeetJobPeer::IS_ACTIVATED, true);
        return self::doSelect($criteria);
    }


    static public function getForSlug($slug)
    {
        $criteria = new Criteria();
        $criteria->add(self::SLUG, $slug);

        return self::doSelectOne($criteria);
    }
}
